﻿CREATE PROCEDURE [acms].[Post_GetBySiteIdAndUrl]
	@SiteId int, 
	@Url varchar(255)
AS
	SELECT *
	FROM Post_View
	WHERE 
		SiteId = @SiteId
		and isNull(ParentPath, '') + Name = @Url
RETURN 0;